LOAD DATA
characterset UTF8
APPEND INTO TABLE numberiden
FIELDS TERMINATED BY ','
trailing nullcols
(
rangetime date "yyyy-mm-dd hh24:mi:ss",
imsi,
linename,
trainnumber,
upordown
)